package com.wdy.golden.tinysql.constant;

/**  
 * @author Dongye_Wu
 * @version: 1.0.0
 * @Description: TODO
 * @date 2020年4月11日 下午9:44:46 
 */
public class TinysqlConstants {
	
	public static final String[] queryPrefix = {"with","select"};
	public static final String[] updatePrefix = {"update","insert","delete"};
//	public static final String[] callPrefix = {"call"};

//	public final static SimpleDateFormat SIMPLE_DATE_FORMAT = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
	public final static String BLANK = " ";
	public final static String COMMA = ",";
	public final static String POINT = ".";
	public final static String COLON = ":";
	public final static String QUOTE  = "'";
	public final static String ASTERISK  = "*";
	public final static String WELLNUMBER  = "#";
	
	public final static String DEFAULT_ID_COLUMN_NAME = "ID";
	public final static String DEFAULT_ID_FIELD_NAME = "id";
	
	public final static String NAMED_PARAMETER_SYMBOL = "=:";
	
	//分页sql前缀
	public final static String PAGINATION_PREFIX  = "select * from ( select t1.*, rownum as rowno from (";
	//分页sql后缀
	public final static String PAGINATION_SUFFIX  = ") t1 where rownum <= %s ) t2 where t2.rowno >= %s";
	//
	public final static String DEFAULT_PAGINATION_ROWSTART  = "rowStart";
	public final static String DEFAULT_PAGINATION_ROWEND  = "rowEnd";
	
	
	//count sql前缀
	public final static String COUNT_PREFIX  = "SELECT count(1) as rowcount from (";
	//count sql后缀
	public final static String COUNT_SUFFIX  = ") tt";
	

	//主键生成方式 custom
	public final static String ID_GENETATOR_CUSTOM  = "custom";
	//主键生成方式 sequence
	public final static String ID_GENETATOR_SEQUENCE  = "sequence";
	
}
